SELECT SEQNO,MATNR,MAKTX_C,ISNULL((SELECT TOP 1 KBETR  FROM Z907 WHERE KSCHL = 'YPR0' AND VKORG IN('2000') 
AND Z907.MATNR=GOODS_V.MATNR),0) NETPR,MEINS,UMREZ,GROES 
FROM GOODS_V
WHERE WERKS='CSHA'